Screenshot_IrfanView

Saves a screenshot of the entire screen into a file using IrfanView (i_view32. ...

MatchLastIf

Finds last occurrence of a match in a column Finds the row of last time an ...

DirTree.xlsb

Excel macro to show all files found in directory (including sub-directories) as ...

DirTree.zip

OpenOffice Macros

A pdf book, for macros in OpenOffice.org

MinIF and MaxIF in Excel 2010

MinIF to calculate smallest number matching certain criteria, in Excel 2010 ...

MaxIF_MinIF_byNMR.zip

CSS Buttons B4BS

This was used widely on my end before we got Bootstrap. Still have potential ...

CSS-Buttons.zip

Run macro

Runs a macro from another workbook (Workbook has to be open).

Permission Denied error

Issue: Trying to copy file (Using VB command FileCopy) while that file was ...

XLShortcut_EnableDisable

Disables or Enables certain Excel built-in shortcut. Code has example on how ...

Styles_DeleteNonStandard

Delete styles from an Excel workbook, any non-standard style will be deleted. ...

Textbox focus issue fix

Trick to force textbox with multiple lines and scrollbars to refresh itself ...

ANmaVBATemplate

Template to be used for any new tools, having... D sheet, WelcomeSheet, code ...

ANmaVBATemplatev2021.14.zip